.. _`HJoin Table`:

.. _`org.sysess.sympathy.data.table.hjointable`:

HJoin Table
```````````

.. image:: hjoin_table.svg
   :width: 48


HJoin Tables into a single Table, stacking columns next to each other




Documentation
:::::::::::::

The operation of horizontal join, or HJoin, stacks the columns in the incoming
Tables horizontally, next to each other. The colunms in the output Table will
be union of columns from the input Tables.

If the option 'Complement missing rows' is unchecked (the default) then all the
inpnut Tables must have the same number of rows. Otherwise, Tables with fewer
rows are padded with masked values.


If a column name exists in more than one input Table the column from the lower
port will take precedence and the corresponding column from the upper port will
be lost.

The second port can be duplicated, making it possible to join several inputs
using one node. To join a dynamic number of tables use
:ref:`org.sysess.sympathy.data.table.hjointablessingle`.

Table name
==========
The node always tries to give the output table a name, so if the chosen
port has a table without name, the other port will be used. This is
to preserve backwards compatibility.


Definition
::::::::::


Input ports
===========

    **port1** 1 - 1,  table
        Input Table

    **port2** 1 - inf,  table
        Input Table


Output ports
============

    **port1**  table
        Table with horizontally joined data




Configuration
=============

    **Complement missing rows** (mask)
        Select if rows that are not represented in all Tables should be complemented with masked values
    **Input port name for joined table** (name)
        Select which port decides the output table(s) names
    **Rename duplicate columns** (rename)
        If true columns with same name as an earlier column will be renamed and joined, otherwise columns will overwrite existing data





Related nodes
=============

* :ref:`org.sysess.sympathy.data.table.hjointables`

* :ref:`org.sysess.sympathy.data.table.hjointablessingle`

* :ref:`org.sysess.sympathy.data.table.hsplittablenode`




Examples
========

* :download:`HJoinTable.syx </Examples/Sympathy/Data Processing/Structure/HJoinTable.syx>`




Implementation
==============

.. automodule:: node_hjoin_tables
    :noindex:

.. class:: HJoinTable
    :noindex: